--INSERT TABLE Customer--------
INSERT INTO Customer(Name,Phone,Email,Address) 
VALUES('Dinh Van An','01662487865','an.luffy93@gmail.com','Thai Binh'),
   ('Nguyen Van Bang','01662487567','boonnv@gmail.com','Ha Noi'),
   ('Tran Quoc Vuong','01666487479','vuongtq@gmail.com','Thai Binh'),
   ('Trinh Thanh Binh', '123', 'abc@gmail.com', 'Yen Bai')
GO

--INSERT TABLE OverDraftLimit--
INSERT INTO dbo.OverDraftLimit (Detail, Value)
VALUES ('ABC Detail', 50000)
GO

--INSERT TABLE WithDrawLimit--
INSERT INTO dbo.WithDrawLimit(Detail, Value)
VALUES ('Min', 50000),  ('Max', 2000000)
GO

--INSERT TABLE Account--
INSERT INTO dbo.[Account]([CustID],[ODID],[WDID],[Balance])
VALUES (1,1,1,5000000)
INSERT INTO dbo.[Account]([CustID],[ODID],[WDID],[Balance])
VALUES (2,1,2,5000000)
INSERT INTO dbo.[Account]([CustID],[ODID],[WDID],[Balance])
VALUES (3,1,2,5000000)
GO

--INSERT TABLE Card--
INSERT INTO dbo.[Card]([CardNo],[Status],[AccountID],[PIN],[StartDate],[ExpiredDate],[Attempt])
VALUES ('1234567890','Active',1,'123456','2014-08-23','2016-08-23',0)
INSERT INTO dbo.[Card]([CardNo],[Status],[AccountID],[PIN],[StartDate],[ExpiredDate],[Attempt])
VALUES ('1234567891','Active',2,'123456','2014-08-23','2016-08-23',0)
INSERT INTO dbo.[Card]([CardNo],[Status],[AccountID],[PIN],[StartDate],[ExpiredDate],[Attempt])
VALUES ('1234567892','Block',3,'123456','2014-08-23','2016-08-23',0),
	 ('1234567893','Active',4,'123456','2014-07-03','2016-07-03',0)
GO
 
--INSERT TABLE ATM--------
INSERT INTO ATM(Branch,Address)
VALUES('Bac Tu Liem','Minh Khai,Tu Liem,Ha Noi'),
   ('Cau Giay','Xuan Thuy,Cau Giay,Ha Noi'),
   ('Bac Tu Liem','My Dinh,Tu Liem,Ha Noi')
GO

--INSERT TABLE Money--
INSERT INTO [dbo].[Money]([MoneyValue])
VALUES(10000),(20000),(50000),(100000),(200000),(500000)
GO

--INSERT TABLE Config--
INSERT INTO [dbo].[Config]([DateModified],[MinWithDraw],[MaxWithDraw])
VALUES('2014/08/27',50000,5000000)
GO

--INSERT TABLE Stock--
INsERT INTO [dbo].[Stock]([MoneyID],[ATMID],[Quantity])
VALUES(1,1,100),(2,1,100),(3,1,50),(4,1,20),(5,1,20),(6,1,20)
GO

--INSERT TABLE LogType
INSERT INTO dbo.LogType(Detail, Description)
VALUES ('Rut Tien','Rut tien mat '),
  ('Xem So Du ', 'Kiem Tra so tien mat co trong the'),
  ('Chuyen Khoan', 'Chuyen tien qua cac the voi nhau'),
  ('Thanh Toan', 'Thuc hien thanh toan tu dong qua the')
GO

--INSERT TABLE Log--
INSERT INTO dbo.Log (LogTypeID, ATMID, CardNo, LogDate, Amount, Details)
VALUES (1, 2, '12562A434', '03-04-2013', 300000, 'Nothing'),
  (2, 1, '12562B434', '02-07-2013', 350000, 'Nothing'),
  (3, 3, '12562B434', '04-04-2013', 600000, 'Nothing'),
  (2, 3, '12562C434', '01-08-2013', 500000, 'Nothing'),
  (4, 2, '12562C434', '02-09-2013', 350000, 'Nothing'),
  (2, 1, '12562A434', '03-01-2013', 400000, 'Nothing')
GO